/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 100505
 Source Host           : localhost:3306
 Source Schema         : eladmin

 Target Server Type    : MySQL
 Target Server Version : 100505
 File Encoding         : 65001

 Date: 05/09/2020 10:49:19
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for code_column_config
-- ----------------------------
DROP TABLE IF EXISTS code_column_config;
CREATE TABLE code_column_config (
  column_id bigint(20) NOT NULL PRIMARY KEY,
  table_name varchar(180) DEFAULT NULL,
  column_name varchar(255) DEFAULT NULL,
  column_type varchar(255) DEFAULT NULL,
  dict_name varchar(255) DEFAULT NULL,
  extra varchar(255) DEFAULT NULL,
  form_show bit(1) DEFAULT NULL,
  form_type varchar(255) DEFAULT NULL,
  key_type varchar(255) DEFAULT NULL,
  list_show bit(1) DEFAULT NULL,
  not_null bit(1) DEFAULT NULL,
  query_type varchar(255) DEFAULT NULL,
  remark varchar(255) DEFAULT NULL,
  date_annotation varchar(255) DEFAULT NULL,
  PRIMARY KEY (column_id) USING BTREE,
  KEY idx_table_name (table_name)
) ENGINE=InnoDB AUTO_INCREMENT=191 ROW_FORMAT=COMPACT COMMENT='代码生成字段信息存储';

-- ----------------------------
-- Table structure for code_gen_config
-- ----------------------------
DROP TABLE IF EXISTS code_gen_config;
CREATE TABLE code_gen_config (
  config_id bigint(20) NOT NULL PRIMARY KEY,
  table_name varchar(255) DEFAULT NULL COMMENT '表名',
  author varchar(255) DEFAULT NULL COMMENT '作者',
  cover bit(1) DEFAULT NULL COMMENT '是否覆盖',
  module_name varchar(255) DEFAULT NULL COMMENT '模块名称',
  pack varchar(255) DEFAULT NULL COMMENT '至于哪个包下',
  path varchar(255) DEFAULT NULL COMMENT '前端代码生成的路径',
  api_path varchar(255) DEFAULT NULL COMMENT '前端Api文件路径',
  prefix varchar(255) DEFAULT NULL COMMENT '表前缀',
  api_alias varchar(255) DEFAULT NULL COMMENT '接口名称',
  PRIMARY KEY (config_id) USING BTREE,
  KEY idx_table_name (table_name(100))
) ENGINE=InnoDB AUTO_INCREMENT=7 ROW_FORMAT=COMPACT COMMENT='代码生成器配置';

-- ----------------------------
-- Table structure for mnt_app
-- ----------------------------
DROP TABLE IF EXISTS mnt_app;
CREATE TABLE mnt_app (
  app_id bigint(20) NOT NULL PRIMARY KEY,
  name varchar(255) DEFAULT NULL COMMENT '应用名称',
  upload_path varchar(255) DEFAULT NULL COMMENT '上传目录',
  deploy_path varchar(255) DEFAULT NULL COMMENT '部署路径',
  backup_path varchar(255) DEFAULT NULL COMMENT '备份路径',
  port int(255) DEFAULT NULL COMMENT '应用端口',
  start_script varchar(4000) DEFAULT NULL COMMENT '启动脚本',
  deploy_script varchar(4000) DEFAULT NULL COMMENT '部署脚本',
  create_by varchar(255) DEFAULT NULL COMMENT '创建者',
  update_by varchar(255) DEFAULT NULL COMMENT '更新者',
  create_time datetime DEFAULT NULL COMMENT '创建日期',
  update_time datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (app_id) USING BTREE
) ENGINE=InnoDB ROW_FORMAT=COMPACT COMMENT='应用管理';

-- ----------------------------
-- Records of mnt_app
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for mnt_database
-- ----------------------------
DROP TABLE IF EXISTS mnt_database;
CREATE TABLE mnt_database (
  db_id varchar(50) NOT NULL COMMENT 'ID',
  name varchar(255) NOT NULL COMMENT '名称',
  jdbc_url varchar(255) NOT NULL COMMENT 'jdbc连接',
  user_name varchar(255) NOT NULL COMMENT '账号',
  pwd varchar(255) NOT NULL COMMENT '密码',
  create_by varchar(255) DEFAULT NULL COMMENT '创建者',
  update_by varchar(255) DEFAULT NULL COMMENT '更新者',
  create_time datetime DEFAULT NULL COMMENT '创建时间',
  update_time datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (db_id) USING BTREE
) ENGINE=InnoDB ROW_FORMAT=COMPACT COMMENT='数据库管理';

-- ----------------------------
-- Records of mnt_database
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for mnt_deploy
-- ----------------------------
DROP TABLE IF EXISTS mnt_deploy;
CREATE TABLE mnt_deploy (
  deploy_id bigint(20) NOT NULL PRIMARY KEY,
  app_id bigint(20) DEFAULT NULL COMMENT '应用编号',
  create_by varchar(255) DEFAULT NULL COMMENT '创建者',
  update_by varchar(255) DEFAULT NULL COMMENT '更新者',
  create_time datetime DEFAULT NULL,
  update_time datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (deploy_id) USING BTREE,
  KEY FK6sy157pseoxx4fmcqr1vnvvhy (app_id) USING BTREE
) ENGINE=InnoDB ROW_FORMAT=COMPACT COMMENT='部署管理';

-- ----------------------------
-- Records of mnt_deploy
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for mnt_deploy_history
-- ----------------------------
DROP TABLE IF EXISTS mnt_deploy_history;
CREATE TABLE mnt_deploy_history (
  history_id varchar(50) NOT NULL COMMENT 'ID',
  app_name varchar(255) NOT NULL COMMENT '应用名称',
  deploy_date datetime NOT NULL COMMENT '部署日期',
  deploy_user varchar(50) NOT NULL COMMENT '部署用户',
  ip varchar(20) NOT NULL COMMENT '服务器IP',
  deploy_id bigint(20) DEFAULT NULL COMMENT '部署编号',
  PRIMARY KEY (history_id) USING BTREE
) ENGINE=InnoDB ROW_FORMAT=COMPACT COMMENT='部署历史管理';

-- ----------------------------
-- Records of mnt_deploy_history
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for mnt_deploy_server
-- ----------------------------
DROP TABLE IF EXISTS mnt_deploy_server;
CREATE TABLE mnt_deploy_server (
  deploy_id bigint(20) NOT NULL COMMENT '部署ID',
  server_id bigint(20) NOT NULL COMMENT '服务ID',
  PRIMARY KEY (deploy_id,server_id) USING BTREE,
  KEY FKeaaha7jew9a02b3bk9ghols53 (server_id) USING BTREE
) ENGINE=InnoDB ROW_FORMAT=COMPACT COMMENT='应用与服务器关联';

-- ----------------------------
-- Records of mnt_deploy_server
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for mnt_server
-- ----------------------------
DROP TABLE IF EXISTS mnt_server;
CREATE TABLE mnt_server (
  server_id bigint(20) NOT NULL PRIMARY KEY,
  account varchar(50) DEFAULT NULL COMMENT '账号',
  ip varchar(20) DEFAULT NULL COMMENT 'IP地址',
  name varchar(100) DEFAULT NULL COMMENT '名称',
  password varchar(100) DEFAULT NULL COMMENT '密码',
  port int(11) DEFAULT NULL COMMENT '端口',
  create_by varchar(255) DEFAULT NULL COMMENT '创建者',
  update_by varchar(255) DEFAULT NULL COMMENT '更新者',
  create_time datetime DEFAULT NULL COMMENT '创建时间',
  update_time datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (server_id) USING BTREE,
  KEY idx_ip (ip)
) ENGINE=InnoDB AUTO_INCREMENT=2 ROW_FORMAT=COMPACT COMMENT='服务器管理';

-- ----------------------------
-- Table structure for sys_dept
-- ----------------------------
DROP TABLE IF EXISTS sys_dept;
CREATE TABLE sys_dept (
  dept_id bigint(20) NOT NULL PRIMARY KEY,
  pid bigint(20) DEFAULT NULL COMMENT '上级部门',
  sub_count int(5) DEFAULT 0 COMMENT '子部门数目',
  name varchar(255) NOT NULL COMMENT '名称',
  dept_sort int(5) DEFAULT 999 COMMENT '排序',
  enabled bit(1) NOT NULL COMMENT '状态',
  create_by varchar(255) DEFAULT NULL COMMENT '创建者',
  update_by varchar(255) DEFAULT NULL COMMENT '更新者',
  create_time datetime DEFAULT NULL COMMENT '创建日期',
  update_time datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (dept_id) USING BTREE,
  KEY inx_pid (pid),
  KEY inx_enabled (enabled)
) ENGINE=InnoDB AUTO_INCREMENT=18 ROW_FORMAT=COMPACT COMMENT='部门';

-- ----------------------------
-- Records of sys_dept
-- ----------------------------
BEGIN;
INSERT INTO sys_dept VALUES (2, 7, 1, '研发部', 3, b'1', 'admin', 'admin', '2019-03-25 09:15:32', '2020-08-02 14:48:47');
INSERT INTO sys_dept VALUES (5, 7, 0, '运维部', 4, b'1', 'admin', 'admin', '2019-03-25 09:20:44', '2020-05-17 14:27:27');
INSERT INTO sys_dept VALUES (6, 8, 0, '测试部', 6, b'1', 'admin', 'admin', '2019-03-25 09:52:18', '2020-06-08 11:59:21');
INSERT INTO sys_dept VALUES (7, NULL, 2, '华南分部', 0, b'1', 'admin', 'admin', '2019-03-25 11:04:50', '2020-06-08 12:08:56');
INSERT INTO sys_dept VALUES (8, NULL, 2, '华北分部', 1, b'1', 'admin', 'admin', '2019-03-25 11:04:53', '2020-05-14 12:54:00');
INSERT INTO sys_dept VALUES (15, 8, 0, 'UI部门', 7, b'1', 'admin', 'admin', '2020-05-13 22:56:53', '2020-05-14 12:54:13');
INSERT INTO sys_dept VALUES (17, 2, 0, '研发一组', 999, b'1', 'admin', 'admin', '2020-08-02 14:49:07', '2020-08-02 14:49:07');
COMMIT;

-- ----------------------------
-- Table structure for sys_dict
-- ----------------------------
DROP TABLE IF EXISTS sys_dict;
CREATE TABLE sys_dict (
  dict_id bigint(20) NOT NULL PRIMARY KEY,
  name varchar(255) NOT NULL COMMENT '字典名称',
  description varchar(255) DEFAULT NULL COMMENT '描述',
  create_by varchar(255) DEFAULT NULL COMMENT '创建者',
  update_by varchar(255) DEFAULT NULL COMMENT '更新者',
  create_time datetime DEFAULT NULL COMMENT '创建日期',
  update_time datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (dict_id) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=6 ROW_FORMAT=COMPACT COMMENT='数据字典';

-- ----------------------------
-- Records of sys_dict
-- ----------------------------
BEGIN;
INSERT INTO sys_dict VALUES (1, 'user_status', '用户状态', NULL, NULL, '2019-10-27 20:31:36', NULL);
INSERT INTO sys_dict VALUES (4, 'dept_status', '部门状态', NULL, NULL, '2019-10-27 20:31:36', NULL);
INSERT INTO sys_dict VALUES (5, 'job_status', '岗位状态', NULL, NULL, '2019-10-27 20:31:36', NULL);
COMMIT;

-- ----------------------------
-- Table structure for sys_dict_detail
-- ----------------------------
DROP TABLE IF EXISTS sys_dict_detail;
CREATE TABLE sys_dict_detail (
  detail_id bigint(20) NOT NULL PRIMARY KEY,
  dict_id bigint(11) DEFAULT NULL COMMENT '字典id',
  label varchar(255) NOT NULL COMMENT '字典标签',
  value varchar(255) NOT NULL COMMENT '字典值',
  dict_sort int(5) DEFAULT NULL COMMENT '排序',
  create_by varchar(255) DEFAULT NULL COMMENT '创建者',
  update_by varchar(255) DEFAULT NULL COMMENT '更新者',
  create_time datetime DEFAULT NULL COMMENT '创建日期',
  update_time datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (detail_id) USING BTREE,
  KEY FK5tpkputc6d9nboxojdbgnpmyb (dict_id) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=7 ROW_FORMAT=COMPACT COMMENT='数据字典详情';

-- ----------------------------
-- Records of sys_dict_detail
-- ----------------------------
BEGIN;
INSERT INTO sys_dict_detail VALUES (1, 1, '激活', 'true', 1, NULL, NULL, '2019-10-27 20:31:36', NULL);
INSERT INTO sys_dict_detail VALUES (2, 1, '禁用', 'false', 2, NULL, NULL, NULL, NULL);
INSERT INTO sys_dict_detail VALUES (3, 4, '启用', 'true', 1, NULL, NULL, NULL, NULL);
INSERT INTO sys_dict_detail VALUES (4, 4, '停用', 'false', 2, NULL, NULL, '2019-10-27 20:31:36', NULL);
INSERT INTO sys_dict_detail VALUES (5, 5, '启用', 'true', 1, NULL, NULL, NULL, NULL);
INSERT INTO sys_dict_detail VALUES (6, 5, '停用', 'false', 2, NULL, NULL, '2019-10-27 20:31:36', NULL);
COMMIT;

-- ----------------------------
-- Table structure for sys_job
-- ----------------------------
DROP TABLE IF EXISTS sys_job;
CREATE TABLE sys_job (
  job_id bigint(20) NOT NULL PRIMARY KEY,
  name varchar(180) NOT NULL COMMENT '岗位名称',
  enabled bit(1) NOT NULL COMMENT '岗位状态',
  job_sort int(5) DEFAULT NULL COMMENT '排序',
  create_by varchar(255) DEFAULT NULL COMMENT '创建者',
  update_by varchar(255) DEFAULT NULL COMMENT '更新者',
  create_time datetime DEFAULT NULL COMMENT '创建日期',
  update_time datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (job_id) USING BTREE,
  UNIQUE KEY uniq_name (name),
  KEY inx_enabled (enabled)
) ENGINE=InnoDB AUTO_INCREMENT=13 ROW_FORMAT=COMPACT COMMENT='岗位';

-- ----------------------------
-- Records of sys_job
-- ----------------------------
BEGIN;
INSERT INTO sys_job VALUES (8, '人事专员', b'1', 3, NULL, NULL, '2019-03-29 14:52:28', NULL);
INSERT INTO sys_job VALUES (10, '产品经理', b'1', 4, NULL, NULL, '2019-03-29 14:55:51', NULL);
INSERT INTO sys_job VALUES (11, '全栈开发', b'1', 2, NULL, 'admin', '2019-03-31 13:39:30', '2020-05-05 11:33:43');
INSERT INTO sys_job VALUES (12, '软件测试', b'1', 5, NULL, 'admin', '2019-03-31 13:39:43', '2020-05-10 19:56:26');
COMMIT;

-- ----------------------------
-- Table structure for sys_log
-- ----------------------------
DROP TABLE IF EXISTS sys_log;
CREATE TABLE sys_log (
  log_id bigint(20) NOT NULL PRIMARY KEY,
  description varchar(255) DEFAULT NULL,
  log_type varchar(10) DEFAULT NULL,
  method varchar(255) DEFAULT NULL,
  params text DEFAULT NULL,
  request_ip varchar(255) DEFAULT NULL,
  time bigint(20) DEFAULT NULL,
  username varchar(255) DEFAULT NULL,
  address varchar(255) DEFAULT NULL,
  browser varchar(255) DEFAULT NULL,
  exception_detail text DEFAULT NULL,
  create_time datetime DEFAULT NULL,
  PRIMARY KEY (log_id) USING BTREE,
  KEY log_create_time_index (create_time),
  KEY inx_log_type (log_type)
) ENGINE=InnoDB AUTO_INCREMENT=3537 ROW_FORMAT=COMPACT COMMENT='系统日志';

-- ----------------------------
-- Table structure for sys_menu
-- ----------------------------
DROP TABLE IF EXISTS sys_menu;
CREATE TABLE sys_menu (
  menu_id bigint(20) NOT NULL PRIMARY KEY,
  pid bigint(20) DEFAULT NULL COMMENT '上级菜单ID',
  sub_count int(5) DEFAULT 0 COMMENT '子菜单数目',
  type int(11) DEFAULT NULL COMMENT '菜单类型',
  title varchar(100) DEFAULT NULL COMMENT '菜单标题',
  name varchar(100) DEFAULT NULL COMMENT '组件名称',
  component varchar(255) DEFAULT NULL COMMENT '组件',
  menu_sort int(5) DEFAULT NULL COMMENT '排序',
  icon varchar(255) DEFAULT NULL COMMENT '图标',
  path varchar(255) DEFAULT NULL COMMENT '链接地址',
  i_frame bit(1) DEFAULT NULL COMMENT '是否外链',
  cache bit(1) DEFAULT b'0' COMMENT '缓存',
  hidden bit(1) DEFAULT b'0' COMMENT '隐藏',
  permission varchar(255) DEFAULT NULL COMMENT '权限',
  create_by varchar(255) DEFAULT NULL COMMENT '创建者',
  update_by varchar(255) DEFAULT NULL COMMENT '更新者',
  create_time datetime DEFAULT NULL COMMENT '创建日期',
  update_time datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (menu_id) USING BTREE,
  UNIQUE KEY uniq_title (title),
  UNIQUE KEY uniq_name (name),
  KEY inx_pid (pid)
) ENGINE=InnoDB AUTO_INCREMENT=118 ROW_FORMAT=COMPACT COMMENT='系统菜单';

-- ----------------------------
-- Records of sys_menu
-- ----------------------------
BEGIN;
INSERT INTO sys_menu (menu_id, pid, sub_count, type, title, name, component, menu_sort, icon, path, cache, hidden, i_frame, permission, create_by, update_by, create_time, update_time)  VALUES (1, NULL, 7, 0, '系统管理', NULL, NULL, 1, 'system', 'system', b'0', b'0', FALSE, NULL, NULL, NULL, '2018-12-18 15:11:29', NULL);
INSERT INTO sys_menu (menu_id, pid, sub_count, type, title, name, component, menu_sort, icon, path, cache, hidden, i_frame, permission, create_by, update_by, create_time, update_time)  VALUES (2, 1, 3, 1, '用户管理', 'User', 'system/user/index', 2, 'peoples', 'user', b'0', b'0', FALSE, 'user:list', NULL, NULL, '2018-12-18 15:14:44', NULL);
INSERT INTO sys_menu (menu_id, pid, sub_count, type, title, name, component, menu_sort, icon, path, cache, hidden, i_frame, permission, create_by, update_by, create_time, update_time)  VALUES (3, 1, 3, 1, '角色管理', 'Role', 'system/role/index', 3, 'role', 'role', b'0', b'0', FALSE, 'roles:list', NULL, NULL, '2018-12-18 15:16:07', NULL);
INSERT INTO sys_menu (menu_id, pid, sub_count, type, title, name, component, menu_sort, icon, path, cache, hidden, i_frame, permission, create_by, update_by, create_time, update_time)  VALUES (5, 1, 3, 1, '菜单管理', 'Menu', 'system/menu/index', 5, 'menu', 'menu', b'0', b'0', FALSE, 'menu:list', NULL, NULL, '2018-12-18 15:17:28', NULL);
INSERT INTO sys_menu (menu_id, pid, sub_count, type, title, name, component, menu_sort, icon, path, cache, hidden, i_frame, permission, create_by, update_by, create_time, update_time)  VALUES (6, NULL, 5, 0, '系统监控', NULL, NULL, 10, 'monitor', 'monitor', b'0', b'0', FALSE, NULL, NULL, NULL, '2018-12-18 15:17:48', NULL);
INSERT INTO sys_menu (menu_id, pid, sub_count, type, title, name, component, menu_sort, icon, path, cache, hidden, i_frame, permission, create_by, update_by, create_time, update_time)  VALUES (7, 6, 0, 1, '操作日志', 'Log', 'monitor/log/index', 11, 'log', 'logs', b'0', b'0', FALSE, NULL, NULL, 'admin', '2018-12-18 15:18:26', '2020-06-06 13:11:57');
INSERT INTO sys_menu (menu_id, pid, sub_count, type, title, name, component, menu_sort, icon, path, cache, hidden, i_frame, permission, create_by, update_by, create_time, update_time)  VALUES (9, 6, 0, 1, 'SQL监控', 'Sql', 'monitor/sql/index', 18, 'sqlMonitor', 'druid', b'0', b'0', FALSE, NULL, NULL, NULL, '2018-12-18 15:19:34', NULL);
INSERT INTO sys_menu (menu_id, pid, sub_count, type, title, name, component, menu_sort, icon, path, cache, hidden, i_frame, permission, create_by, update_by, create_time, update_time)  VALUES (10, NULL, 5, 0, '组件管理', NULL, NULL, 50, 'zujian', 'components', b'0', b'0', FALSE, NULL, NULL, NULL, '2018-12-19 13:38:16', NULL);
INSERT INTO sys_menu (menu_id, pid, sub_count, type, title, name, component, menu_sort, icon, path, cache, hidden, i_frame, permission, create_by, update_by, create_time, update_time)  VALUES (11, 10, 0, 1, '图标库', 'Icons', 'components/icons/index', 51, 'icon', 'icon', b'0', b'0', FALSE, NULL, NULL, NULL, '2018-12-19 13:38:49', NULL);
INSERT INTO sys_menu (menu_id, pid, sub_count, type, title, name, component, menu_sort, icon, path, cache, hidden, i_frame, permission, create_by, update_by, create_time, update_time)  VALUES (14, 36, 0, 1, '邮件工具', 'Email', 'tools/email/index', 35, 'email', 'email', b'0', b'0', FALSE, NULL, NULL, NULL, '2018-12-27 10:13:09', NULL);
INSERT INTO sys_menu (menu_id, pid, sub_count, type, title, name, component, menu_sort, icon, path, cache, hidden, i_frame, permission, create_by, update_by, create_time, update_time)  VALUES (15, 10, 0, 1, '富文本', 'Editor', 'components/Editor', 52, 'fwb', 'tinymce', b'0', b'0', FALSE, NULL, NULL, NULL, '2018-12-27 11:58:25', NULL);
INSERT INTO sys_menu (menu_id, pid, sub_count, type, title, name, component, menu_sort, icon, path, cache, hidden, i_frame, permission, create_by, update_by, create_time, update_time)  VALUES (18, 36, 3, 1, '存储管理', 'Storage', 'tools/storage/index', 34, 'qiniu', 'storage', b'0', b'0', FALSE, 'storage:list', NULL, NULL, '2018-12-31 11:12:15', NULL);
INSERT INTO sys_menu (menu_id, pid, sub_count, type, title, name, component, menu_sort, icon, path, cache, hidden, i_frame, permission, create_by, update_by, create_time, update_time)  VALUES (19, 36, 0, 1, '支付宝工具', 'AliPay', 'tools/aliPay/index', 37, 'alipay', 'aliPay', b'0', b'0', FALSE, NULL, NULL, NULL, '2018-12-31 14:52:38', NULL);
INSERT INTO sys_menu (menu_id, pid, sub_count, type, title, name, component, menu_sort, icon, path, cache, hidden, i_frame, permission, create_by, update_by, create_time, update_time)  VALUES (21, NULL, 2, 0, '多级菜单', NULL, '', 900, 'menu', 'nested', b'0', b'0', FALSE, NULL, NULL, 'admin', '2019-01-04 16:22:03', '2020-06-21 17:27:35');
INSERT INTO sys_menu (menu_id, pid, sub_count, type, title, name, component, menu_sort, icon, path, cache, hidden, i_frame, permission, create_by, update_by, create_time, update_time)  VALUES (22, 21, 2, 0, '二级菜单1', NULL, '', 999, 'menu', 'menu1', b'0', b'0', FALSE, NULL, NULL, 'admin', '2019-01-04 16:23:29', '2020-06-21 17:27:20');
INSERT INTO sys_menu (menu_id, pid, sub_count, type, title, name, component, menu_sort, icon, path, cache, hidden, i_frame, permission, create_by, update_by, create_time, update_time)  VALUES (23, 21, 0, 1, '二级菜单2', NULL, 'nested/menu2/index', 999, 'menu', 'menu2', b'0', b'0', FALSE, NULL, NULL, NULL, '2019-01-04 16:23:57', NULL);
INSERT INTO sys_menu (menu_id, pid, sub_count, type, title, name, component, menu_sort, icon, path, cache, hidden, i_frame, permission, create_by, update_by, create_time, update_time)  VALUES (24, 22, 0, 1, '三级菜单1', 'Test', 'nested/menu1/menu1-1', 999, 'menu', 'menu1-1', b'0', b'0', FALSE, NULL, NULL, NULL, '2019-01-04 16:24:48', NULL);
INSERT INTO sys_menu (menu_id, pid, sub_count, type, title, name, component, menu_sort, icon, path, cache, hidden, i_frame, permission, create_by, update_by, create_time, update_time)  VALUES (27, 22, 0, 1, '三级菜单2', NULL, 'nested/menu1/menu1-2', 999, 'menu', 'menu1-2', b'0', b'0', FALSE, NULL, NULL, NULL, '2019-01-07 17:27:32', NULL);
INSERT INTO sys_menu (menu_id, pid, sub_count, type, title, name, component, menu_sort, icon, path, cache, hidden, i_frame, permission, create_by, update_by, create_time, update_time)  VALUES (28, 1, 3, 1, '任务调度', 'Timing', 'system/timing/index', 999, 'timing', 'timing', b'0', b'0', FALSE, 'timing:list', NULL, NULL, '2019-01-07 20:34:40', NULL);
INSERT INTO sys_menu (menu_id, pid, sub_count, type, title, name, component, menu_sort, icon, path, cache, hidden, i_frame, permission, create_by, update_by, create_time, update_time)  VALUES (30, 36, 0, 1, '代码生成', 'GeneratorIndex', 'generator/index', 32, 'dev', 'generator', b'0', b'0', FALSE, NULL, NULL, NULL, '2019-01-11 15:45:55', NULL);
INSERT INTO sys_menu (menu_id, pid, sub_count, type, title, name, component, menu_sort, icon, path, cache, hidden, i_frame, permission, create_by, update_by, create_time, update_time)  VALUES (32, 6, 0, 1, '异常日志', 'ErrorLog', 'monitor/log/errorLog', 12, 'error', 'errorLog', b'0', b'0', FALSE, NULL, NULL, NULL, '2019-01-13 13:49:03', NULL);
INSERT INTO sys_menu (menu_id, pid, sub_count, type, title, name, component, menu_sort, icon, path, cache, hidden, i_frame, permission, create_by, update_by, create_time, update_time)  VALUES (33, 10, 0, 1, 'Markdown', 'Markdown', 'components/MarkDown', 53, 'markdown', 'markdown', b'0', b'0', FALSE, NULL, NULL, NULL, '2019-03-08 13:46:44', NULL);
INSERT INTO sys_menu (menu_id, pid, sub_count, type, title, name, component, menu_sort, icon, path, cache, hidden, i_frame, permission, create_by, update_by, create_time, update_time)  VALUES (34, 10, 0, 1, 'Yaml编辑器', 'YamlEdit', 'components/YamlEdit', 54, 'dev', 'yaml', b'0', b'0', FALSE, NULL, NULL, NULL, '2019-03-08 15:49:40', NULL);
INSERT INTO sys_menu (menu_id, pid, sub_count, type, title, name, component, menu_sort, icon, path, cache, hidden, i_frame, permission, create_by, update_by, create_time, update_time)  VALUES (35, 1, 3, 1, '部门管理', 'Dept', 'system/dept/index', 6, 'dept', 'dept', b'0', b'0', FALSE, 'dept:list', NULL, NULL, '2019-03-25 09:46:00', NULL);
INSERT INTO sys_menu (menu_id, pid, sub_count, type, title, name, component, menu_sort, icon, path, cache, hidden, i_frame, permission, create_by, update_by, create_time, update_time)  VALUES (36, NULL, 7, 0, '系统工具', NULL, '', 30, 'sys-tools', 'sys-tools', b'0', b'0', FALSE, NULL, NULL, NULL, '2019-03-29 10:57:35', NULL);
INSERT INTO sys_menu (menu_id, pid, sub_count, type, title, name, component, menu_sort, icon, path, cache, hidden, i_frame, permission, create_by, update_by, create_time, update_time)  VALUES (37, 1, 3, 1, '岗位管理', 'Job', 'system/job/index', 7, 'Steve-Jobs', 'job', b'0', b'0', FALSE, 'job:list', NULL, NULL, '2019-03-29 13:51:18', NULL);
INSERT INTO sys_menu (menu_id, pid, sub_count, type, title, name, component, menu_sort, icon, path, cache, hidden, i_frame, permission, create_by, update_by, create_time, update_time)  VALUES (38, 36, 0, 1, '接口文档', 'Swagger', 'tools/swagger/index', 36, 'swagger', 'swagger2', b'0', b'0', FALSE, NULL, NULL, NULL, '2019-03-29 19:57:53', NULL);
INSERT INTO sys_menu (menu_id, pid, sub_count, type, title, name, component, menu_sort, icon, path, cache, hidden, i_frame, permission, create_by, update_by, create_time, update_time)  VALUES (39, 1, 3, 1, '字典管理', 'Dict', 'system/dict/index', 8, 'dictionary', 'dict', b'0', b'0', FALSE, 'dict:list', NULL, NULL, '2019-04-10 11:49:04', NULL);
INSERT INTO sys_menu (menu_id, pid, sub_count, type, title, name, component, menu_sort, icon, path, cache, hidden, i_frame, permission, create_by, update_by, create_time, update_time)  VALUES (41, 6, 0, 1, '在线用户', 'OnlineUser', 'monitor/online/index', 10, 'Steve-Jobs', 'online', b'0', b'0', FALSE, NULL, NULL, NULL, '2019-10-26 22:08:43', NULL);
INSERT INTO sys_menu (menu_id, pid, sub_count, type, title, name, component, menu_sort, icon, path, cache, hidden, i_frame, permission, create_by, update_by, create_time, update_time)  VALUES (44, 2, 0, 2, '用户新增', NULL, '', 2, '', '', b'0', b'0', FALSE, 'user:add', NULL, NULL, '2019-10-29 10:59:46', NULL);
INSERT INTO sys_menu (menu_id, pid, sub_count, type, title, name, component, menu_sort, icon, path, cache, hidden, i_frame, permission, create_by, update_by, create_time, update_time)  VALUES (45, 2, 0, 2, '用户编辑', NULL, '', 3, '', '', b'0', b'0', FALSE, 'user:edit', NULL, NULL, '2019-10-29 11:00:08', NULL);
INSERT INTO sys_menu (menu_id, pid, sub_count, type, title, name, component, menu_sort, icon, path, cache, hidden, i_frame, permission, create_by, update_by, create_time, update_time)  VALUES (46, 2, 0, 2, '用户删除', NULL, '', 4, '', '', b'0', b'0', FALSE, 'user:del', NULL, NULL, '2019-10-29 11:00:23', NULL);
INSERT INTO sys_menu (menu_id, pid, sub_count, type, title, name, component, menu_sort, icon, path, cache, hidden, i_frame, permission, create_by, update_by, create_time, update_time)  VALUES (48, 3, 0, 2, '角色创建', NULL, '', 2, '', '', b'0', b'0', FALSE, 'roles:add', NULL, NULL, '2019-10-29 12:45:34', NULL);
INSERT INTO sys_menu (menu_id, pid, sub_count, type, title, name, component, menu_sort, icon, path, cache, hidden, i_frame, permission, create_by, update_by, create_time, update_time)  VALUES (49, 3, 0, 2, '角色修改', NULL, '', 3, '', '', b'0', b'0', FALSE, 'roles:edit', NULL, NULL, '2019-10-29 12:46:16', NULL);
INSERT INTO sys_menu (menu_id, pid, sub_count, type, title, name, component, menu_sort, icon, path, cache, hidden, i_frame, permission, create_by, update_by, create_time, update_time)  VALUES (50, 3, 0, 2, '角色删除', NULL, '', 4, '', '', b'0', b'0', FALSE, 'roles:del', NULL, NULL, '2019-10-29 12:46:51', NULL);
INSERT INTO sys_menu (menu_id, pid, sub_count, type, title, name, component, menu_sort, icon, path, cache, hidden, i_frame, permission, create_by, update_by, create_time, update_time)  VALUES (52, 5, 0, 2, '菜单新增', NULL, '', 2, '', '', b'0', b'0', FALSE, 'menu:add', NULL, NULL, '2019-10-29 12:55:07', NULL);
INSERT INTO sys_menu (menu_id, pid, sub_count, type, title, name, component, menu_sort, icon, path, cache, hidden, i_frame, permission, create_by, update_by, create_time, update_time)  VALUES (53, 5, 0, 2, '菜单编辑', NULL, '', 3, '', '', b'0', b'0', FALSE, 'menu:edit', NULL, NULL, '2019-10-29 12:55:40', NULL);
INSERT INTO sys_menu (menu_id, pid, sub_count, type, title, name, component, menu_sort, icon, path, cache, hidden, i_frame, permission, create_by, update_by, create_time, update_time)  VALUES (54, 5, 0, 2, '菜单删除', NULL, '', 4, '', '', b'0', b'0', FALSE, 'menu:del', NULL, NULL, '2019-10-29 12:56:00', NULL);
INSERT INTO sys_menu (menu_id, pid, sub_count, type, title, name, component, menu_sort, icon, path, cache, hidden, i_frame, permission, create_by, update_by, create_time, update_time)  VALUES (56, 35, 0, 2, '部门新增', NULL, '', 2, '', '', b'0', b'0', FALSE, 'dept:add', NULL, NULL, '2019-10-29 12:57:09', NULL);
INSERT INTO sys_menu (menu_id, pid, sub_count, type, title, name, component, menu_sort, icon, path, cache, hidden, i_frame, permission, create_by, update_by, create_time, update_time)  VALUES (57, 35, 0, 2, '部门编辑', NULL, '', 3, '', '', b'0', b'0', FALSE, 'dept:edit', NULL, NULL, '2019-10-29 12:57:27', NULL);
INSERT INTO sys_menu (menu_id, pid, sub_count, type, title, name, component, menu_sort, icon, path, cache, hidden, i_frame, permission, create_by, update_by, create_time, update_time)  VALUES (58, 35, 0, 2, '部门删除', NULL, '', 4, '', '', b'0', b'0', FALSE, 'dept:del', NULL, NULL, '2019-10-29 12:57:41', NULL);
INSERT INTO sys_menu (menu_id, pid, sub_count, type, title, name, component, menu_sort, icon, path, cache, hidden, i_frame, permission, create_by, update_by, create_time, update_time)  VALUES (60, 37, 0, 2, '岗位新增', NULL, '', 2, '', '', b'0', b'0', FALSE, 'job:add', NULL, NULL, '2019-10-29 12:58:27', NULL);
INSERT INTO sys_menu (menu_id, pid, sub_count, type, title, name, component, menu_sort, icon, path, cache, hidden, i_frame, permission, create_by, update_by, create_time, update_time)  VALUES (61, 37, 0, 2, '岗位编辑', NULL, '', 3, '', '', b'0', b'0', FALSE, 'job:edit', NULL, NULL, '2019-10-29 12:58:45', NULL);
INSERT INTO sys_menu (menu_id, pid, sub_count, type, title, name, component, menu_sort, icon, path, cache, hidden, i_frame, permission, create_by, update_by, create_time, update_time)  VALUES (62, 37, 0, 2, '岗位删除', NULL, '', 4, '', '', b'0', b'0', FALSE, 'job:del', NULL, NULL, '2019-10-29 12:59:04', NULL);
INSERT INTO sys_menu (menu_id, pid, sub_count, type, title, name, component, menu_sort, icon, path, cache, hidden, i_frame, permission, create_by, update_by, create_time, update_time)  VALUES (64, 39, 0, 2, '字典新增', NULL, '', 2, '', '', b'0', b'0', FALSE, 'dict:add', NULL, NULL, '2019-10-29 13:00:17', NULL);
INSERT INTO sys_menu (menu_id, pid, sub_count, type, title, name, component, menu_sort, icon, path, cache, hidden, i_frame, permission, create_by, update_by, create_time, update_time)  VALUES (65, 39, 0, 2, '字典编辑', NULL, '', 3, '', '', b'0', b'0', FALSE, 'dict:edit', NULL, NULL, '2019-10-29 13:00:42', NULL);
INSERT INTO sys_menu (menu_id, pid, sub_count, type, title, name, component, menu_sort, icon, path, cache, hidden, i_frame, permission, create_by, update_by, create_time, update_time)  VALUES (66, 39, 0, 2, '字典删除', NULL, '', 4, '', '', b'0', b'0', FALSE, 'dict:del', NULL, NULL, '2019-10-29 13:00:59', NULL);
INSERT INTO sys_menu (menu_id, pid, sub_count, type, title, name, component, menu_sort, icon, path, cache, hidden, i_frame, permission, create_by, update_by, create_time, update_time)  VALUES (73, 28, 0, 2, '任务新增', NULL, '', 2, '', '', b'0', b'0', FALSE, 'timing:add', NULL, NULL, '2019-10-29 13:07:28', NULL);
INSERT INTO sys_menu (menu_id, pid, sub_count, type, title, name, component, menu_sort, icon, path, cache, hidden, i_frame, permission, create_by, update_by, create_time, update_time)  VALUES (74, 28, 0, 2, '任务编辑', NULL, '', 3, '', '', b'0', b'0', FALSE, 'timing:edit', NULL, NULL, '2019-10-29 13:07:41', NULL);
INSERT INTO sys_menu (menu_id, pid, sub_count, type, title, name, component, menu_sort, icon, path, cache, hidden, i_frame, permission, create_by, update_by, create_time, update_time)  VALUES (75, 28, 0, 2, '任务删除', NULL, '', 4, '', '', b'0', b'0', FALSE, 'timing:del', NULL, NULL, '2019-10-29 13:07:54', NULL);
INSERT INTO sys_menu (menu_id, pid, sub_count, type, title, name, component, menu_sort, icon, path, cache, hidden, i_frame, permission, create_by, update_by, create_time, update_time)  VALUES (77, 18, 0, 2, '上传文件', NULL, '', 2, '', '', b'0', b'0', FALSE, 'storage:add', NULL, NULL, '2019-10-29 13:09:09', NULL);
INSERT INTO sys_menu (menu_id, pid, sub_count, type, title, name, component, menu_sort, icon, path, cache, hidden, i_frame, permission, create_by, update_by, create_time, update_time)  VALUES (78, 18, 0, 2, '文件编辑', NULL, '', 3, '', '', b'0', b'0', FALSE, 'storage:edit', NULL, NULL, '2019-10-29 13:09:22', NULL);
INSERT INTO sys_menu (menu_id, pid, sub_count, type, title, name, component, menu_sort, icon, path, cache, hidden, i_frame, permission, create_by, update_by, create_time, update_time)  VALUES (79, 18, 0, 2, '文件删除', NULL, '', 4, '', '', b'0', b'0', FALSE, 'storage:del', NULL, NULL, '2019-10-29 13:09:34', NULL);
INSERT INTO sys_menu (menu_id, pid, sub_count, type, title, name, component, menu_sort, icon, path, cache, hidden, i_frame, permission, create_by, update_by, create_time, update_time)  VALUES (80, 6, 0, 1, '服务监控', 'ServerMonitor', 'monitor/server/index', 14, 'codeConsole', 'server', b'0', b'0', FALSE, 'monitor:list', NULL, 'admin', '2019-11-07 13:06:39', '2020-05-04 18:20:50');
INSERT INTO sys_menu (menu_id, pid, sub_count, type, title, name, component, menu_sort, icon, path, cache, hidden, i_frame, permission, create_by, update_by, create_time, update_time)  VALUES (82, 36, 0, 1, '生成配置', 'GeneratorConfig', 'generator/config', 33, 'dev', 'generator/config/:tableName', b'0', b'1', b'1', '', NULL, NULL, '2019-11-17 20:08:56', NULL);
INSERT INTO sys_menu (menu_id, pid, sub_count, type, title, name, component, menu_sort, icon, path, cache, hidden, i_frame, permission, create_by, update_by, create_time, update_time)  VALUES (83, 10, 0, 1, '图表库', 'Echarts', 'components/Echarts', 50, 'chart', 'echarts', b'0', b'0', FALSE, '', NULL, NULL, '2019-11-21 09:04:32', NULL);
INSERT INTO sys_menu (menu_id, pid, sub_count, type, title, name, component, menu_sort, icon, path, cache, hidden, i_frame, permission, create_by, update_by, create_time, update_time)  VALUES (90, NULL, 5, 1, '运维管理', 'Mnt', '', 20, 'mnt', 'mnt', b'0', b'0', FALSE, NULL, NULL, NULL, '2019-11-09 10:31:08', NULL);
INSERT INTO sys_menu (menu_id, pid, sub_count, type, title, name, component, menu_sort, icon, path, cache, hidden, i_frame, permission, create_by, update_by, create_time, update_time)  VALUES (92, 90, 3, 1, '服务器', 'ServerDeploy', 'mnt/server/index', 22, 'server', 'mnt/serverDeploy', b'0', b'0', FALSE, 'serverDeploy:list', NULL, NULL, '2019-11-10 10:29:25', NULL);
INSERT INTO sys_menu (menu_id, pid, sub_count, type, title, name, component, menu_sort, icon, path, cache, hidden, i_frame, permission, create_by, update_by, create_time, update_time)  VALUES (93, 90, 3, 1, '应用管理', 'App', 'mnt/app/index', 23, 'app', 'mnt/app', b'0', b'0', FALSE, 'app:list', NULL, NULL, '2019-11-10 11:05:16', NULL);
INSERT INTO sys_menu (menu_id, pid, sub_count, type, title, name, component, menu_sort, icon, path, cache, hidden, i_frame, permission, create_by, update_by, create_time, update_time)  VALUES (94, 90, 3, 1, '部署管理', 'Deploy', 'mnt/deploy/index', 24, 'deploy', 'mnt/deploy', b'0', b'0', FALSE, 'deploy:list', NULL, NULL, '2019-11-10 15:56:55', NULL);
INSERT INTO sys_menu (menu_id, pid, sub_count, type, title, name, component, menu_sort, icon, path, cache, hidden, i_frame, permission, create_by, update_by, create_time, update_time)  VALUES (97, 90, 1, 1, '部署备份', 'DeployHistory', 'mnt/deployHistory/index', 25, 'backup', 'mnt/deployHistory', b'0', b'0', FALSE, 'deployHistory:list', NULL, NULL, '2019-11-10 16:49:44', NULL);
INSERT INTO sys_menu (menu_id, pid, sub_count, type, title, name, component, menu_sort, icon, path, cache, hidden, i_frame, permission, create_by, update_by, create_time, update_time)  VALUES (98, 90, 3, 1, '数据库管理', 'Database', 'mnt/database/index', 26, 'database', 'mnt/database', b'0', b'0', FALSE, 'database:list', NULL, NULL, '2019-11-10 20:40:04', NULL);
INSERT INTO sys_menu (menu_id, pid, sub_count, type, title, name, component, menu_sort, icon, path, cache, hidden, i_frame, permission, create_by, update_by, create_time, update_time)  VALUES (102, 97, 0, 2, '删除', NULL, '', 999, '', '', b'0', b'0', FALSE, 'deployHistory:del', NULL, NULL, '2019-11-17 09:32:48', NULL);
INSERT INTO sys_menu (menu_id, pid, sub_count, type, title, name, component, menu_sort, icon, path, cache, hidden, i_frame, permission, create_by, update_by, create_time, update_time)  VALUES (103, 92, 0, 2, '服务器新增', NULL, '', 999, '', '', b'0', b'0', FALSE, 'serverDeploy:add', NULL, NULL, '2019-11-17 11:08:33', NULL);
INSERT INTO sys_menu (menu_id, pid, sub_count, type, title, name, component, menu_sort, icon, path, cache, hidden, i_frame, permission, create_by, update_by, create_time, update_time)  VALUES (104, 92, 0, 2, '服务器编辑', NULL, '', 999, '', '', b'0', b'0', FALSE, 'serverDeploy:edit', NULL, NULL, '2019-11-17 11:08:57', NULL);
INSERT INTO sys_menu (menu_id, pid, sub_count, type, title, name, component, menu_sort, icon, path, cache, hidden, i_frame, permission, create_by, update_by, create_time, update_time)  VALUES (105, 92, 0, 2, '服务器删除', NULL, '', 999, '', '', b'0', b'0', FALSE, 'serverDeploy:del', NULL, NULL, '2019-11-17 11:09:15', NULL);
INSERT INTO sys_menu (menu_id, pid, sub_count, type, title, name, component, menu_sort, icon, path, cache, hidden, i_frame, permission, create_by, update_by, create_time, update_time)  VALUES (106, 93, 0, 2, '应用新增', NULL, '', 999, '', '', b'0', b'0', FALSE, 'app:add', NULL, NULL, '2019-11-17 11:10:03', NULL);
INSERT INTO sys_menu (menu_id, pid, sub_count, type, title, name, component, menu_sort, icon, path, cache, hidden, i_frame, permission, create_by, update_by, create_time, update_time)  VALUES (107, 93, 0, 2, '应用编辑', NULL, '', 999, '', '', b'0', b'0', FALSE, 'app:edit', NULL, NULL, '2019-11-17 11:10:28', NULL);
INSERT INTO sys_menu (menu_id, pid, sub_count, type, title, name, component, menu_sort, icon, path, cache, hidden, i_frame, permission, create_by, update_by, create_time, update_time)  VALUES (108, 93, 0, 2, '应用删除', NULL, '', 999, '', '', b'0', b'0', FALSE, 'app:del', NULL, NULL, '2019-11-17 11:10:55', NULL);
INSERT INTO sys_menu (menu_id, pid, sub_count, type, title, name, component, menu_sort, icon, path, cache, hidden, i_frame, permission, create_by, update_by, create_time, update_time)  VALUES (109, 94, 0, 2, '部署新增', NULL, '', 999, '', '', b'0', b'0', FALSE, 'deploy:add', NULL, NULL, '2019-11-17 11:11:22', NULL);
INSERT INTO sys_menu (menu_id, pid, sub_count, type, title, name, component, menu_sort, icon, path, cache, hidden, i_frame, permission, create_by, update_by, create_time, update_time)  VALUES (110, 94, 0, 2, '部署编辑', NULL, '', 999, '', '', b'0', b'0', FALSE, 'deploy:edit', NULL, NULL, '2019-11-17 11:11:41', NULL);
INSERT INTO sys_menu (menu_id, pid, sub_count, type, title, name, component, menu_sort, icon, path, cache, hidden, i_frame, permission, create_by, update_by, create_time, update_time)  VALUES (111, 94, 0, 2, '部署删除', NULL, '', 999, '', '', b'0', b'0', FALSE, 'deploy:del', NULL, NULL, '2019-11-17 11:12:01', NULL);
INSERT INTO sys_menu (menu_id, pid, sub_count, type, title, name, component, menu_sort, icon, path, cache, hidden, i_frame, permission, create_by, update_by, create_time, update_time)  VALUES (112, 98, 0, 2, '数据库新增', NULL, '', 999, '', '', b'0', b'0', FALSE, 'database:add', NULL, NULL, '2019-11-17 11:12:43', NULL);
INSERT INTO sys_menu (menu_id, pid, sub_count, type, title, name, component, menu_sort, icon, path, cache, hidden, i_frame, permission, create_by, update_by, create_time, update_time)  VALUES (113, 98, 0, 2, '数据库编辑', NULL, '', 999, '', '', b'0', b'0', FALSE, 'database:edit', NULL, NULL, '2019-11-17 11:12:58', NULL);
INSERT INTO sys_menu (menu_id, pid, sub_count, type, title, name, component, menu_sort, icon, path, cache, hidden, i_frame, permission, create_by, update_by, create_time, update_time)  VALUES (114, 98, 0, 2, '数据库删除', NULL, '', 999, '', '', b'0', b'0', FALSE, 'database:del', NULL, NULL, '2019-11-17 11:13:14', NULL);
INSERT INTO sys_menu (menu_id, pid, sub_count, type, title, name, component, menu_sort, icon, path, cache, hidden, i_frame, permission, create_by, update_by, create_time, update_time)  VALUES (116, 36, 0, 1, '生成预览', 'Preview', 'generator/preview', 999, 'java', 'generator/preview/:tableName', b'0', b'1', b'1', NULL, NULL, NULL, '2019-11-26 14:54:36', NULL);
COMMIT;

-- ----------------------------
-- Table structure for sys_quartz_job
-- ----------------------------
DROP TABLE IF EXISTS sys_quartz_job;
CREATE TABLE sys_quartz_job (
  job_id bigint(20) NOT NULL PRIMARY KEY,
  bean_name varchar(255) DEFAULT NULL COMMENT 'Spring Bean名称',
  cron_expression varchar(255) DEFAULT NULL COMMENT 'cron 表达式',
  is_pause bit(1) DEFAULT NULL COMMENT '状态：1暂停、0启用',
  job_name varchar(255) DEFAULT NULL COMMENT '任务名称',
  method_name varchar(255) DEFAULT NULL COMMENT '方法名称',
  params varchar(255) DEFAULT NULL COMMENT '参数',
  description varchar(255) DEFAULT NULL COMMENT '备注',
  person_in_charge varchar(100) DEFAULT NULL COMMENT '负责人',
  email varchar(100) DEFAULT NULL COMMENT '报警邮箱',
  sub_task varchar(100) DEFAULT NULL COMMENT '子任务ID',
  pause_after_failure bit(1) DEFAULT NULL COMMENT '任务失败后是否暂停',
  create_by varchar(255) DEFAULT NULL COMMENT '创建者',
  update_by varchar(255) DEFAULT NULL COMMENT '更新者',
  create_time datetime DEFAULT NULL COMMENT '创建日期',
  update_time datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (job_id) USING BTREE,
  KEY inx_is_pause (is_pause)
) ENGINE=InnoDB AUTO_INCREMENT=7 ROW_FORMAT=COMPACT COMMENT='定时任务';

-- ----------------------------
-- Records of sys_quartz_job
-- ----------------------------
BEGIN;
INSERT INTO sys_quartz_job VALUES (2, 'testTask', '0/5 * * * * ?', b'1', '测试1', 'run1', 'test', '带参测试，多参使用json', '测试', NULL, NULL, NULL, NULL, 'admin', '2019-08-22 14:08:29', '2020-05-24 13:58:33');
INSERT INTO sys_quartz_job VALUES (3, 'testTask', '0/5 * * * * ?', b'1', '测试', 'run', '', '不带参测试', 'Zheng Jie', '', '5,6', b'1', NULL, 'admin', '2019-09-26 16:44:39', '2020-05-24 14:48:12');
INSERT INTO sys_quartz_job VALUES (5, 'Test', '0/5 * * * * ?', b'1', '任务告警测试', 'run', NULL, '测试', 'test', '', NULL, b'1', 'admin', 'admin', '2020-05-05 20:32:41', '2020-05-05 20:36:13');
INSERT INTO sys_quartz_job VALUES (6, 'testTask', '0/5 * * * * ?', b'1', '测试3', 'run2', NULL, '测试3', 'Zheng Jie', '', NULL, b'1', 'admin', 'admin', '2020-05-05 20:35:41', '2020-05-05 20:36:07');
COMMIT;

-- ----------------------------
-- Table structure for sys_quartz_log
-- ----------------------------
DROP TABLE IF EXISTS sys_quartz_log;
CREATE TABLE sys_quartz_log (
  log_id bigint(20) NOT NULL PRIMARY KEY,
  bean_name varchar(255) DEFAULT NULL,
  create_time datetime DEFAULT NULL,
  cron_expression varchar(255) DEFAULT NULL,
  exception_detail text DEFAULT NULL,
  is_success bit(1) DEFAULT NULL,
  job_name varchar(255) DEFAULT NULL,
  method_name varchar(255) DEFAULT NULL,
  params varchar(255) DEFAULT NULL,
  time bigint(20) DEFAULT NULL,
  PRIMARY KEY (log_id) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=151 ROW_FORMAT=COMPACT COMMENT='定时任务日志';

-- ----------------------------
-- Table structure for sys_role
-- ----------------------------
DROP TABLE IF EXISTS sys_role;
CREATE TABLE sys_role (
  role_id bigint(20) NOT NULL PRIMARY KEY,
  name varchar(100) NOT NULL COMMENT '名称',
  level int(50) DEFAULT NULL COMMENT '角色级别',
  description varchar(255) DEFAULT NULL COMMENT '描述',
  data_scope varchar(255) DEFAULT NULL COMMENT '数据权限',
  create_by varchar(255) DEFAULT NULL COMMENT '创建者',
  update_by varchar(255) DEFAULT NULL COMMENT '更新者',
  create_time datetime DEFAULT NULL COMMENT '创建日期',
  update_time datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (role_id) USING BTREE,
  UNIQUE KEY uniq_name (name),
  KEY role_name_index (name)
) ENGINE=InnoDB AUTO_INCREMENT=3 ROW_FORMAT=COMPACT COMMENT='角色表';

-- ----------------------------
-- Records of sys_role
-- ----------------------------
BEGIN;
INSERT INTO sys_role VALUES (1, '超级管理员', 1, '-', '全部', NULL, 'admin', '2018-11-23 11:04:37', '2020-08-06 16:10:24');
INSERT INTO sys_role VALUES (2, '普通用户', 2, '-', '本级', NULL, 'admin', '2018-11-23 13:09:06', '2020-09-05 10:45:12');
COMMIT;

-- ----------------------------
-- Table structure for sys_roles_depts
-- ----------------------------
DROP TABLE IF EXISTS sys_roles_depts;
CREATE TABLE sys_roles_depts (
  role_id bigint(20) NOT NULL,
  dept_id bigint(20) NOT NULL,
  PRIMARY KEY (role_id,dept_id) USING BTREE,
  KEY FK7qg6itn5ajdoa9h9o78v9ksur (dept_id) USING BTREE
) ENGINE=InnoDB ROW_FORMAT=COMPACT COMMENT='角色部门关联';

-- ----------------------------
-- Table structure for sys_roles_menus
-- ----------------------------
DROP TABLE IF EXISTS sys_roles_menus;
CREATE TABLE sys_roles_menus (
  menu_id bigint(20) NOT NULL COMMENT '菜单ID',
  role_id bigint(20) NOT NULL COMMENT '角色ID',
  PRIMARY KEY (menu_id,role_id) USING BTREE,
  KEY FKcngg2qadojhi3a651a5adkvbq (role_id) USING BTREE
) ENGINE=InnoDB ROW_FORMAT=COMPACT COMMENT='角色菜单关联';

-- ----------------------------
-- Records of sys_roles_menus
-- ----------------------------
BEGIN;
INSERT INTO sys_roles_menus VALUES (1, 1);
INSERT INTO sys_roles_menus VALUES (2, 1);
INSERT INTO sys_roles_menus VALUES (3, 1);
INSERT INTO sys_roles_menus VALUES (5, 1);
INSERT INTO sys_roles_menus VALUES (6, 1);
INSERT INTO sys_roles_menus VALUES (7, 1);
INSERT INTO sys_roles_menus VALUES (9, 1);
INSERT INTO sys_roles_menus VALUES (10, 1);
INSERT INTO sys_roles_menus VALUES (11, 1);
INSERT INTO sys_roles_menus VALUES (14, 1);
INSERT INTO sys_roles_menus VALUES (15, 1);
INSERT INTO sys_roles_menus VALUES (18, 1);
INSERT INTO sys_roles_menus VALUES (19, 1);
INSERT INTO sys_roles_menus VALUES (21, 1);
INSERT INTO sys_roles_menus VALUES (22, 1);
INSERT INTO sys_roles_menus VALUES (23, 1);
INSERT INTO sys_roles_menus VALUES (24, 1);
INSERT INTO sys_roles_menus VALUES (27, 1);
INSERT INTO sys_roles_menus VALUES (28, 1);
INSERT INTO sys_roles_menus VALUES (30, 1);
INSERT INTO sys_roles_menus VALUES (32, 1);
INSERT INTO sys_roles_menus VALUES (33, 1);
INSERT INTO sys_roles_menus VALUES (34, 1);
INSERT INTO sys_roles_menus VALUES (35, 1);
INSERT INTO sys_roles_menus VALUES (36, 1);
INSERT INTO sys_roles_menus VALUES (37, 1);
INSERT INTO sys_roles_menus VALUES (38, 1);
INSERT INTO sys_roles_menus VALUES (39, 1);
INSERT INTO sys_roles_menus VALUES (41, 1);
INSERT INTO sys_roles_menus VALUES (44, 1);
INSERT INTO sys_roles_menus VALUES (45, 1);
INSERT INTO sys_roles_menus VALUES (46, 1);
INSERT INTO sys_roles_menus VALUES (48, 1);
INSERT INTO sys_roles_menus VALUES (49, 1);
INSERT INTO sys_roles_menus VALUES (50, 1);
INSERT INTO sys_roles_menus VALUES (52, 1);
INSERT INTO sys_roles_menus VALUES (53, 1);
INSERT INTO sys_roles_menus VALUES (54, 1);
INSERT INTO sys_roles_menus VALUES (56, 1);
INSERT INTO sys_roles_menus VALUES (57, 1);
INSERT INTO sys_roles_menus VALUES (58, 1);
INSERT INTO sys_roles_menus VALUES (60, 1);
INSERT INTO sys_roles_menus VALUES (61, 1);
INSERT INTO sys_roles_menus VALUES (62, 1);
INSERT INTO sys_roles_menus VALUES (64, 1);
INSERT INTO sys_roles_menus VALUES (65, 1);
INSERT INTO sys_roles_menus VALUES (66, 1);
INSERT INTO sys_roles_menus VALUES (73, 1);
INSERT INTO sys_roles_menus VALUES (74, 1);
INSERT INTO sys_roles_menus VALUES (75, 1);
INSERT INTO sys_roles_menus VALUES (77, 1);
INSERT INTO sys_roles_menus VALUES (78, 1);
INSERT INTO sys_roles_menus VALUES (79, 1);
INSERT INTO sys_roles_menus VALUES (80, 1);
INSERT INTO sys_roles_menus VALUES (82, 1);
INSERT INTO sys_roles_menus VALUES (83, 1);
INSERT INTO sys_roles_menus VALUES (90, 1);
INSERT INTO sys_roles_menus VALUES (92, 1);
INSERT INTO sys_roles_menus VALUES (93, 1);
INSERT INTO sys_roles_menus VALUES (94, 1);
INSERT INTO sys_roles_menus VALUES (97, 1);
INSERT INTO sys_roles_menus VALUES (98, 1);
INSERT INTO sys_roles_menus VALUES (102, 1);
INSERT INTO sys_roles_menus VALUES (103, 1);
INSERT INTO sys_roles_menus VALUES (104, 1);
INSERT INTO sys_roles_menus VALUES (105, 1);
INSERT INTO sys_roles_menus VALUES (106, 1);
INSERT INTO sys_roles_menus VALUES (107, 1);
INSERT INTO sys_roles_menus VALUES (108, 1);
INSERT INTO sys_roles_menus VALUES (109, 1);
INSERT INTO sys_roles_menus VALUES (110, 1);
INSERT INTO sys_roles_menus VALUES (111, 1);
INSERT INTO sys_roles_menus VALUES (112, 1);
INSERT INTO sys_roles_menus VALUES (113, 1);
INSERT INTO sys_roles_menus VALUES (114, 1);
INSERT INTO sys_roles_menus VALUES (116, 1);
INSERT INTO sys_roles_menus VALUES (1, 2);
INSERT INTO sys_roles_menus VALUES (2, 2);
INSERT INTO sys_roles_menus VALUES (6, 2);
INSERT INTO sys_roles_menus VALUES (7, 2);
INSERT INTO sys_roles_menus VALUES (9, 2);
INSERT INTO sys_roles_menus VALUES (10, 2);
INSERT INTO sys_roles_menus VALUES (11, 2);
INSERT INTO sys_roles_menus VALUES (14, 2);
INSERT INTO sys_roles_menus VALUES (15, 2);
INSERT INTO sys_roles_menus VALUES (19, 2);
INSERT INTO sys_roles_menus VALUES (21, 2);
INSERT INTO sys_roles_menus VALUES (22, 2);
INSERT INTO sys_roles_menus VALUES (23, 2);
INSERT INTO sys_roles_menus VALUES (24, 2);
INSERT INTO sys_roles_menus VALUES (27, 2);
INSERT INTO sys_roles_menus VALUES (30, 2);
INSERT INTO sys_roles_menus VALUES (32, 2);
INSERT INTO sys_roles_menus VALUES (33, 2);
INSERT INTO sys_roles_menus VALUES (34, 2);
INSERT INTO sys_roles_menus VALUES (36, 2);
INSERT INTO sys_roles_menus VALUES (80, 2);
INSERT INTO sys_roles_menus VALUES (82, 2);
INSERT INTO sys_roles_menus VALUES (83, 2);
INSERT INTO sys_roles_menus VALUES (116, 2);
COMMIT;

-- ----------------------------
-- Table structure for sys_user
-- ----------------------------
DROP TABLE IF EXISTS sys_user;
CREATE TABLE sys_user (
  user_id bigint(20) NOT NULL PRIMARY KEY,
  dept_id bigint(20) DEFAULT NULL COMMENT '部门名称',
  username varchar(180) DEFAULT NULL COMMENT '用户名',
  nick_name varchar(255) DEFAULT NULL COMMENT '昵称',
  gender varchar(2) DEFAULT NULL COMMENT '性别',
  phone varchar(255) DEFAULT NULL COMMENT '手机号码',
  email varchar(180) DEFAULT NULL COMMENT '邮箱',
  avatar_name varchar(255) DEFAULT NULL COMMENT '头像地址',
  avatar_path varchar(255) DEFAULT NULL COMMENT '头像真实路径',
  password varchar(255) DEFAULT NULL COMMENT '密码',
  is_admin bit(1) DEFAULT b'0' COMMENT '是否为admin账号',
  enabled  bit(1) DEFAULT NULL COMMENT '状态：1启用、0禁用',
  create_by varchar(255) DEFAULT NULL COMMENT '创建者',
  update_by varchar(255) DEFAULT NULL COMMENT '更新者',
  pwd_reset_time datetime DEFAULT NULL COMMENT '修改密码的时间',
  create_time datetime DEFAULT NULL COMMENT '创建日期',
  update_time datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (user_id) USING BTREE,
  UNIQUE KEY UK_kpubos9gc2cvtkb0thktkbkes (email) USING BTREE,
  UNIQUE KEY username (username) USING BTREE,
  UNIQUE KEY uniq_username (username),
  UNIQUE KEY uniq_email (email),
  KEY FK5rwmryny6jthaaxkogownknqp (dept_id) USING BTREE,
  KEY inx_enabled (enabled)
) ENGINE=InnoDB AUTO_INCREMENT=3 ROW_FORMAT=COMPACT COMMENT='系统用户';

-- ----------------------------
-- Records of sys_user
-- ----------------------------
BEGIN;
INSERT INTO sys_user VALUES (1, 2, 'admin', '管理员', '男', '18888888888', '201507802@qq.com', 'avatar-20200806032259161.png', '/Users/jie/Documents/work/me/admin/eladmin/~/avatar/avatar-20200806032259161.png', '$2a$10$Egp1/gvFlt7zhlXVfEFw4OfWQCGPw0ClmMcc6FjTnvXNRVf9zdMRa', b'1', 1, NULL, 'admin', '2020-05-03 16:38:31', '2018-08-23 09:11:56', '2020-09-05 10:43:31');
INSERT INTO sys_user VALUES (2, 2, 'test', '测试', '男', '19999999999', '231@qq.com', NULL, NULL, '$2a$10$4XcyudOYTSz6fue6KFNMHeUQnCX5jbBQypLEnGk1PmekXt5c95JcK', b'0', 1, 'admin', 'admin', NULL, '2020-05-05 11:15:49', '2020-09-05 10:43:38');
COMMIT;

-- ----------------------------
-- Table structure for sys_users_jobs
-- ----------------------------
DROP TABLE IF EXISTS sys_users_jobs;
CREATE TABLE sys_users_jobs (
  user_id bigint(20) NOT NULL COMMENT '用户ID',
  job_id bigint(20) NOT NULL COMMENT '岗位ID',
  PRIMARY KEY (user_id,job_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of sys_users_jobs
-- ----------------------------
BEGIN;
INSERT INTO sys_users_jobs VALUES (1, 11);
INSERT INTO sys_users_jobs VALUES (2, 12);
COMMIT;

-- ----------------------------
-- Table structure for sys_users_roles
-- ----------------------------
DROP TABLE IF EXISTS sys_users_roles;
CREATE TABLE sys_users_roles (
  user_id bigint(20) NOT NULL COMMENT '用户ID',
  role_id bigint(20) NOT NULL COMMENT '角色ID',
  PRIMARY KEY (user_id,role_id) USING BTREE,
  KEY FKq4eq273l04bpu4efj0jd0jb98 (role_id) USING BTREE
) ENGINE=InnoDB ROW_FORMAT=COMPACT COMMENT='用户角色关联';

-- ----------------------------
-- Records of sys_users_roles
-- ----------------------------
BEGIN;
INSERT INTO sys_users_roles VALUES (1, 1);
INSERT INTO sys_users_roles VALUES (2, 2);
COMMIT;

-- ----------------------------
-- Table structure for tool_alipay_config
-- ----------------------------
DROP TABLE IF EXISTS tool_alipay_config;
CREATE TABLE tool_alipay_config (
  config_id bigint(20) NOT NULL COMMENT 'ID',
  app_id varchar(255) DEFAULT NULL COMMENT '应用ID',
  charset varchar(255) DEFAULT NULL COMMENT '编码',
  format varchar(255) DEFAULT NULL COMMENT '类型 固定格式json',
  gateway_url varchar(255) DEFAULT NULL COMMENT '网关地址',
  notify_url varchar(255) DEFAULT NULL COMMENT '异步回调',
  private_key text DEFAULT NULL COMMENT '私钥',
  public_key text DEFAULT NULL COMMENT '公钥',
  return_url varchar(255) DEFAULT NULL COMMENT '回调地址',
  sign_type varchar(255) DEFAULT NULL COMMENT '签名方式',
  sys_service_provider_id varchar(255) DEFAULT NULL COMMENT '商户号',
  PRIMARY KEY (config_id) USING BTREE
) ENGINE=InnoDB ROW_FORMAT=COMPACT COMMENT='支付宝配置类';

-- ----------------------------
-- Records of tool_alipay_config
-- ----------------------------
BEGIN;
INSERT INTO tool_alipay_config VALUES (1, '2016091700532697', 'utf-8', 'JSON', 'https://openapi.alipaydev.com/gateway.do', 'http://api.auauz.net/api/aliPay/notify', 'MIIEvAIBADANBgkqhkiG9w0BAQEFAASCBKYwggSiAgEAAoIBAQC5js8sInU10AJ0cAQ8UMMyXrQ+oHZEkVt5lBwsStmTJ7YikVYgbskx1YYEXTojRsWCb+SH/kDmDU4pK/u91SJ4KFCRMF2411piYuXU/jF96zKrADznYh/zAraqT6hvAIVtQAlMHN53nx16rLzZ/8jDEkaSwT7+HvHiS+7sxSojnu/3oV7BtgISoUNstmSe8WpWHOaWv19xyS+Mce9MY4BfseFhzTICUymUQdd/8hXA28/H6osUfAgsnxAKv7Wil3aJSgaJczWuflYOve0dJ3InZkhw5Cvr0atwpk8YKBQjy5CdkoHqvkOcIB+cYHXJKzOE5tqU7inSwVbHzOLQ3XbnAgMBAAECggEAVJp5eT0Ixg1eYSqFs9568WdetUNCSUchNxDBu6wxAbhUgfRUGZuJnnAll63OCTGGck+EGkFh48JjRcBpGoeoHLL88QXlZZbC/iLrea6gcDIhuvfzzOffe1RcZtDFEj9hlotg8dQj1tS0gy9pN9g4+EBH7zeu+fyv+qb2e/v1l6FkISXUjpkD7RLQr3ykjiiEw9BpeKb7j5s7Kdx1NNIzhkcQKNqlk8JrTGDNInbDM6inZfwwIO2R1DHinwdfKWkvOTODTYa2MoAvVMFT9Bec9FbLpoWp7ogv1JMV9svgrcF9XLzANZ/OQvkbe9TV9GWYvIbxN6qwQioKCWO4GPnCAQKBgQDgW5MgfhX8yjXqoaUy/d1VjI8dHeIyw8d+OBAYwaxRSlCfyQ+tieWcR2HdTzPca0T0GkWcKZm0ei5xRURgxt4DUDLXNh26HG0qObbtLJdu/AuBUuCqgOiLqJ2f1uIbrz6OZUHns+bT/jGW2Ws8+C13zTCZkZt9CaQsrp3QOGDx5wKBgQDTul39hp3ZPwGNFeZdkGoUoViOSd5Lhowd5wYMGAEXWRLlU8z+smT5v0POz9JnIbCRchIY2FAPKRdVTICzmPk2EPJFxYTcwaNbVqL6lN7J2IlXXMiit5QbiLauo55w7plwV6LQmKm9KV7JsZs5XwqF7CEovI7GevFzyD3w+uizAQKBgC3LY1eRhOlpWOIAhpjG6qOoohmeXOphvdmMlfSHq6WYFqbWwmV4rS5d/6LNpNdL6fItXqIGd8I34jzql49taCmi+A2nlR/E559j0mvM20gjGDIYeZUz5MOE8k+K6/IcrhcgofgqZ2ZED1ksHdB/E8DNWCswZl16V1FrfvjeWSNnAoGAMrBplCrIW5xz+J0Hm9rZKrs+AkK5D4fUv8vxbK/KgxZ2KaUYbNm0xv39c+PZUYuFRCz1HDGdaSPDTE6WeWjkMQd5mS6ikl9hhpqFRkyh0d0fdGToO9yLftQKOGE/q3XUEktI1XvXF0xyPwNgUCnq0QkpHyGVZPtGFxwXiDvpvgECgYA5PoB+nY8iDiRaJNko9w0hL4AeKogwf+4TbCw+KWVEn6jhuJa4LFTdSqp89PktQaoVpwv92el/AhYjWOl/jVCm122f9b7GyoelbjMNolToDwe5pF5RnSpEuDdLy9MfE8LnE3PlbE7E5BipQ3UjSebkgNboLHH/lNZA5qvEtvbfvQ==', 'MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAut9evKRuHJ/2QNfDlLwvN/S8l9hRAgPbb0u61bm4AtzaTGsLeMtScetxTWJnVvAVpMS9luhEJjt+Sbk5TNLArsgzzwARgaTKOLMT1TvWAK5EbHyI+eSrc3s7Awe1VYGwcubRFWDm16eQLv0k7iqiw+4mweHSz/wWyvBJVgwLoQ02btVtAQErCfSJCOmt0Q/oJQjj08YNRV4EKzB19+f5A+HQVAKy72dSybTzAK+3FPtTtNen/+b5wGeat7c32dhYHnGorPkPeXLtsqqUTp1su5fMfd4lElNdZaoCI7osZxWWUo17vBCZnyeXc9fk0qwD9mK6yRAxNbrY72Xx5VqIqwIDAQAB', 'http://api.auauz.net/api/aliPay/return', 'RSA2', '2088102176044281');
COMMIT;

-- ----------------------------
-- Table structure for tool_email_config
-- ----------------------------
DROP TABLE IF EXISTS tool_email_config;
CREATE TABLE tool_email_config (
  config_id bigint(20) NOT NULL COMMENT 'ID',
  from_user varchar(255) DEFAULT NULL COMMENT '收件人',
  host varchar(255) DEFAULT NULL COMMENT '邮件服务器SMTP地址',
  pass varchar(255) DEFAULT NULL COMMENT '密码',
  port varchar(255) DEFAULT NULL COMMENT '端口',
  user varchar(255) DEFAULT NULL COMMENT '发件者用户名',
  PRIMARY KEY (config_id) USING BTREE
) ENGINE=InnoDB ROW_FORMAT=COMPACT COMMENT='邮箱配置';

-- ----------------------------
-- Table structure for tool_local_storage
-- ----------------------------
DROP TABLE IF EXISTS tool_local_storage;
CREATE TABLE tool_local_storage (
  storage_id bigint(20) NOT NULL PRIMARY KEY,
  real_name varchar(255) DEFAULT NULL COMMENT '文件真实的名称',
  name varchar(255) DEFAULT NULL COMMENT '文件名',
  suffix varchar(255) DEFAULT NULL COMMENT '后缀',
  path varchar(255) DEFAULT NULL COMMENT '路径',
  type varchar(255) DEFAULT NULL COMMENT '类型',
  size varchar(100) DEFAULT NULL COMMENT '大小',
  create_by varchar(255) DEFAULT NULL COMMENT '创建者',
  update_by varchar(255) DEFAULT NULL COMMENT '更新者',
  create_time datetime DEFAULT NULL COMMENT '创建日期',
  update_time datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (storage_id) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=10 ROW_FORMAT=COMPACT COMMENT='本地存储';

-- ----------------------------
-- Records of tool_local_storage
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for tool_qiniu_config
-- ----------------------------
DROP TABLE IF EXISTS tool_qiniu_config;
CREATE TABLE tool_qiniu_config (
  config_id bigint(20) NOT NULL COMMENT 'ID',
  access_key text DEFAULT NULL COMMENT 'accessKey',
  bucket varchar(255) DEFAULT NULL COMMENT 'Bucket 识别符',
  host varchar(255) NOT NULL COMMENT '外链域名',
  secret_key text DEFAULT NULL COMMENT 'secretKey',
  type varchar(255) DEFAULT NULL COMMENT '空间类型',
  zone varchar(255) DEFAULT NULL COMMENT '机房',
  PRIMARY KEY (config_id) USING BTREE
) ENGINE=InnoDB ROW_FORMAT=COMPACT COMMENT='七牛云配置';

-- ----------------------------
-- Table structure for tool_qiniu_content
-- ----------------------------
DROP TABLE IF EXISTS tool_qiniu_content;
CREATE TABLE tool_qiniu_content (
  content_id bigint(20) NOT NULL PRIMARY KEY,
  bucket varchar(255) DEFAULT NULL COMMENT 'Bucket 识别符',
  name varchar(180) DEFAULT NULL COMMENT '文件名称',
  size varchar(255) DEFAULT NULL COMMENT '文件大小',
  type varchar(255) DEFAULT NULL COMMENT '文件类型：私有或公开',
  url varchar(255) DEFAULT NULL COMMENT '文件url',
  suffix varchar(255) DEFAULT NULL COMMENT '文件后缀',
  update_time datetime DEFAULT NULL COMMENT '上传或同步的时间',
  PRIMARY KEY (content_id) USING BTREE,
  UNIQUE KEY uniq_name (name)
) ENGINE=InnoDB ROW_FORMAT=COMPACT COMMENT='七牛云文件存储';

-- ----------------------------
-- Records of tool_qiniu_content
-- ----------------------------
BEGIN;
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;